BEGIN;

ALTER TABLE school ADD COLUMN district_id INT(11) NOT NULL;
ALTER TABLE school ADD FOREIGN KEY (district_id) REFERENCES district(id) ON DELETE CASCADE;

COMMIT;